Can you infer the owners of each credit card and loyalty card? What is your evidence? Where are there uncertainties in your method? Where are there uncertainties in the data? Please limit your answer to 8 images and 500 words.
Yes, we can infer some of the owners of each credit card and loyalty card by cross-checking credit card and vehicle data using map and later join credit card transaction with loyalty card transaction.
Step by step example to infer the owner of each credit card and loyalty card :
With this method, not all credit card and loyalty card owner can be known. There are some scenarios that make the transaction data hard to be traced.
There is also a possibility that some people going to the shop by using another vehicle (not company vehicle) or for some coffee/breakfast place, some employee might walk there since it is very near from their house
Employees did go to the shop by company vehicle, however, it is not them who paid the bill
Not all employees paid the bill using credit card, there might be some people who use their loyalty card, but paid the bill using cash
Given the data sources provided, identify potential informal or unofficial relationships among GASTech personnel. Provide evidence for these relationships. Please limit your response to 8 images and 500 words.
Reading layer `Abila' from data source
`C:\jovinkahartanto\assignment_distill\MC2\Geospatial'
using driver `ESRI Shapefile'
Simple feature collection with 3290 features and 9 fields
Geometry type: LINESTRING
Dimension: XY
Bounding box: xmin: 24.82401 ymin: 36.04502 xmax: 24.90997 ymax: 36.09492
Geodetic CRS: WGS 84
They usually visited the meeting point during lunch time, around 11:30 AM to 12:30 PM. There are also few cases where two or three of them visited these places at the same times.
The date, time, and duration of these 4 employees visiting the 5 unknown places can be seen in the interactive graph below.
As we can see in the graph below, Brand and Elsa always come to Chostus Hotel during lunch time. They came to the hotel with a similar timing, there is a possibility that there is an informal relationship between them.
##Question 5 Do you see evidence of suspicious activity? Identify 1- 10 locations where you believe the suspicious activity is occurring, and why Please limit your response to 10 images and 500 words.
Meeting Point 1,2,4,5,6 As mentioned in Question 4 there are 5 unknown places that repeatedly visited by 4 employees
GASTech Technologies Data table below shows that car id 1, which is Nils Calixto visit GASTech at night, later than 8 PM. There are days that Nils visited GASTech at after 23:00 PM, which is very suspicious.It is also unusual for Truck 104 come to GASTech at 8 PM
Nils Calixto also visited Lars’ House on 7 January 2014 at 3 AM, which is very suspicious.
There are three employees who visited Chostus Hotel, which are Sten Sanjorge Jr. (id:31), Brand Tempestad (id:33), and Elsa Orilla (id:7). However as explained in question 4, only Brand and Elsa are visited the hotel together during lunch time on 8,10,14, and 17 January 2014.
Meanwhile, the remaining visits belongs to Sten Sanjorge Jr s, who stayed in the hotel from 17 January 2014 to 19 January 2014. It can be seen from the time duration that the GPS tracked that Sten’s car syp for almost 19 hours on 17 January, and 23 hours on 18 January 2014.